SQL для тестировщика

Дана следующая таблица

+----+----------+---------+
| ID | Name     | Salary  |
+----+----------+---------+
| 1  | John     | 3000    |
| 2  | Sarah    | 2500    |
| 3  | Michael  | 4000    |
+----+----------+---------+

Какой из следующих SQL запросов отберет работников с зарплатой больше или равной 3000

A)

SELECT * FROM Employees WHERE Salary >= 3000

SELECT * FROM Employees WHERE Salary > 3000

SELECT * FROM Employees WHERE Salary = 3000

D) SELECT * FROM Employees WHERE Salary < 3000

www.tg-me.com/hk/SQL для тестировщика/com.sql_for_qa/105

2.0K viewsJun 14, 2023 at 08:17

tg-me.com/sql_for_qa/105

Create: 2023-06-14
Last Update: 2025-07-01 21:39:19

Дана следующая таблица

+----+----------+---------+ | ID | Name | Salary | +----+----------+---------+ | 1 | John | 3000 | | 2 | Sarah | 2500 | | 3 | Michael | 4000 | +----+----------+---------+Какой из следующих SQL запросов отберет работников с зарплатой больше или равной 3000

A) SELECT * FROM Employees WHERE Salary >= 3000B) SELECT * FROM Employees WHERE Salary > 3000C) SELECT * FROM Employees WHERE Salary = 3000D) SELECT * FROM Employees WHERE Salary < 3000

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/105

SQL для тестировщика Telegram | DID YOU KNOW?

Traders also expressed uncertainty about the situation with China Evergrande, as the indebted property company has not provided clarification about a key interest payment.In economic news, the Commerce Department reported an unexpected increase in U.S. new home sales in August.Crude oil prices climbed Friday and front-month WTI oil futures contracts saw gains for a fifth straight week amid tighter supplies. West Texas Intermediate Crude oil futures for November rose $0.68 or 0.9 percent at 73.98 a barrel. WTI Crude futures gained 2.8 percent for the week.